<%
String eintrag, id, bewertung, header1, inhalt, autor, ort, anzeige_email, email, sql, link_title, link, kategorie;
String tags, beschreibung, id_link, kritik, kommentar_vorhanden, bildlink, plz, strasse, telefon;
id = "";
eintrag = "";
bewertung = "";
header1 = "";
inhalt = "";
autor = "";
ort = "";
anzeige_email = "";
email = "";
link_title = "";
link = "";
tags = "";
beschreibung = "";
id_link = "";
kritik = "";
kommentar_vorhanden = "";
bildlink = "";
plz = "";
strasse = "";
telefon = "";
kategorie = "";
int empfehlungen = 0;
if (request.getQueryString() != null) {
id = request.getParameter("id");
}
try {
Class.forName( "com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection
("jdbc:mysql://localhost/main","admin","zQmxXyUc");
Statement stmt=conn.createStatement();
out.println(" ");
out.println("");
sql="SELECT link_title, Ort, link, tags, Beschreibung, id_link, empfehlungen, kritik, kommentar_vorhanden, bildlink, plz, strasse, telefon, kategorie from kunstkompass_links where id_link = '" +id+ "'";
ResultSet res2=stmt.executeQuery(sql);
res2.last();
if (res2.getRow() > 0 == true) {
res2.beforeFirst();
}
while(res2.next()) {
link_title = res2.getString(1);
ort = res2.getString(2);
link = res2.getString(3);
beschreibung = res2.getString(5);
id_link = res2.getString(6);
empfehlungen = res2.getInt(7);
kommentar_vorhanden = res2.getString(9);
bildlink = res2.getString(10);
plz = res2.getString(11);
strasse = res2.getString(12);
telefon = res2.getString(13);
if (link_title == null) {
link_title = " ";
}
if (ort == null) {
ort = " ";
}
if (link == null) {
link = " ";
}
if (beschreibung == null) {
beschreibung = " ";
}
beschreibung = beschreibung.trim();
if (strasse == null) {
strasse = "";
} else {
strasse = strasse+ ", ";
}
if (plz == null) {
plz = " ";
}
if (telefon == null) {
telefon = " ";
}
if (kommentar_vorhanden == null) {
kommentar_vorhanden = "nein";
}
if ((bildlink != null) && (bildlink.length() > 5 == true)) {
out.println( "");
} else {
out.println( " | ");
}
if (link.equals(" ") == true) {
out.println( " | ");
out.println(" ");
}
out.println(" | ");
}
out.println(" ");
sql="SELECT bewertung, header1, inhalt, autor, ort, anzeige_email, email from kompass_kommentar where id = '" +id+ "'";
ResultSet res=stmt.executeQuery(sql);
res.last();
int a = res.getRow();
if (a > 0 == true) {
out.println("");
eintrag = "vorhanden";
res.beforeFirst();
while(res.next()) {
bewertung = res.getString(1);
header1 = res.getString(2);
inhalt = res.getString(3);
autor = res.getString(4);
ort = res.getString(5);
anzeige_email = res.getString(6);
email = res.getString(7);
out.println("");
if (bewertung.equals("1-Stern") == true) {
out.println(" ");
}
if (bewertung.equals("2-Stern") == true) {
out.println(" ");
}
if (bewertung.equals("3-Sterne") == true) {
out.println(" ");
}
if (bewertung.equals("4-Sterne") == true) {
out.println(" ");
}
if (bewertung.equals("5-Sterne") == true) {
out.println(" ");
}
if (header1.equals("a") != true) {
out.println( header1 );
}
out.println(" | | ");
out.println("");
out.println( inhalt );
out.println(" | | ");
if (autor.equals("a") != true) {
out.println("");
out.println( autor );
if (ort.equals("a") != true) {
out.println(", " +ort );
}
out.println(" | | ");
}
if ((anzeige_email.equals("ja") == true) && (email.equals("a") != true)) {
out.println("");
out.println("" +email+ "");
out.println(" | | ");
}
out.println("");
out.println(" | | ");
}
}
if (eintrag.equals("vorhanden") == true) {
out.println(" ");
}
}
catch(ClassNotFoundException err) {
out.println("DB-Driver nicht gefunden!");
out.println(err);
}
catch(SQLException err) {
out.println("Connect nicht möglich");
out.println(err);
}
%>
|